UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8dsYn+Z4FQtgn8cgcPvU7gS/qEnrYeHk3lFQsCJie8='
WHERE
key_id = '1f78cf484d2536a6153de9e3fcbd7994fbcb104f6911ecb111c347d02a310ecb'
AND (
token = 'g8dsYn+Z4FQtgn8cgcPvU7gS/qEnrYeHk3lFQsCJie8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)