UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4zDhE4VUHG7S8sfj1M6ZTMe16szOAF/bdSFO53bdag='
WHERE
key_id = '8c470f0422bad7c9706b5b2f44ce3406277505ca02f32e166314515298155439'
AND (
token = 'X4zDhE4VUHG7S8sfj1M6ZTMe16szOAF/bdSFO53bdag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)