UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6eMQ4XBPVM+NNN9nj7I4mZWJhDQyHQpFtAeq1WTq7Zo='
WHERE
key_id = '4a2745a2672d68070a073a3fd56de67de18ae98fae7b4bccffdc6d0a63fb29d7'
AND (
token = '6eMQ4XBPVM+NNN9nj7I4mZWJhDQyHQpFtAeq1WTq7Zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)