UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AYVNHDAuWcRYoFBAYdorMBfKAF8LaMI9yodXGYhoJyM='
WHERE
key_id = '46240a36b609550db6646088d7768ef748f96cc93f5d0d8ec726bdfe25b6ef4b'
AND (
token = 'AYVNHDAuWcRYoFBAYdorMBfKAF8LaMI9yodXGYhoJyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)