UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HOgqTRbwcqBoV67MOHiDWJW7T9/JR5QuGXbetHaXNwk='
WHERE
key_id = 'aa2ce3f574122b6120fc70163427322eab8e5628174ec93c0e3f8465eb8ab72e'
AND (
token = 'HOgqTRbwcqBoV67MOHiDWJW7T9/JR5QuGXbetHaXNwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)