UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MLmkyaa0pPky+ucGPHweuDTT5N503VJcYs61l9xpQvE='
WHERE
key_id = '3a47f64430fbb53742b0c3b557a243a752a3cceca206b77be9e40782df7fb5af'
AND (
token = 'MLmkyaa0pPky+ucGPHweuDTT5N503VJcYs61l9xpQvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)