UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MS7EPEs6/0I8oBHIGLUif4OkymlkOHSCavgHbKKNicQ='
WHERE
key_id = '5ee78968e767525a63fda4917b6176e89772358b8f479411e177510b0d744c26'
AND (
token = 'MS7EPEs6/0I8oBHIGLUif4OkymlkOHSCavgHbKKNicQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)