UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MkmzUJBlx3Hk/7rPfHC8tXD+L9zvLOtY4yu8hO5IrU='
WHERE
key_id = 'a25fc5b416eaae76263793d045586812ea068ac52cac8044b0c829037933dbbd'
AND (
token = '8MkmzUJBlx3Hk/7rPfHC8tXD+L9zvLOtY4yu8hO5IrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)