UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MlHoH0TmvanZY+xbqB7nkyHv7iPwTonrfqIX6sayifI='
WHERE
key_id = '3a3c6eac477e54a8a82ab1a7b16545831cf6838bb0c858091cfb9ac638cd2a99'
AND (
token = 'MlHoH0TmvanZY+xbqB7nkyHv7iPwTonrfqIX6sayifI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)