UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzL6J3uDTrry3C2R45GTTcKc7Vq+LrBWszNy+E1nj+k='
WHERE
key_id = 'f7a7857435ed3a82233ef2a6223a0b7cadb100d7569067a4b561e6a4c93bd165'
AND (
token = 'mzL6J3uDTrry3C2R45GTTcKc7Vq+LrBWszNy+E1nj+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)