UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9mp8XyI0wesZkBjDZ/1KfBJAGThTOj0gIQGS905wcA='
WHERE
key_id = 'b98f71f06dc58705ada4e61774184e1fb0009eb4b9a0e506f297b1b5a153f3f6'
AND (
token = '+9mp8XyI0wesZkBjDZ/1KfBJAGThTOj0gIQGS905wcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)