UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zz5rqh4uQpMLTv3aAbjiiPwDYlPBB1MxXdeJmSS4QnM='
WHERE
key_id = '4ea0dc1bd74ec9dcbbd6f115a51d80512090fb1f8d39884b17539c780cb94968'
AND (
token = 'zz5rqh4uQpMLTv3aAbjiiPwDYlPBB1MxXdeJmSS4QnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)