UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5aI5hy+SL5zRyz84/u0NG9XRLzoCOiCGYhyt5vsrsE='
WHERE
key_id = 'e158f7502ed3d12a88e8c4dd8b5bc08d33b4cca13a1e5b1bdfaa64c12f1ae1ce'
AND (
token = '/5aI5hy+SL5zRyz84/u0NG9XRLzoCOiCGYhyt5vsrsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)