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