UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hC9xj+w8AX3C85gpq5fBuBemJsqt4y9sYxet78OL+VI='
WHERE
key_id = '69a4d01cdac1c355de03278c6d9d120716ea679d482e22181d097329a54728cc'
AND (
token = 'hC9xj+w8AX3C85gpq5fBuBemJsqt4y9sYxet78OL+VI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)