UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KosHUABdJuCw+vshuwGBrqnpmtu2flEB9uR/i7JUe9M='
WHERE
key_id = 'c016f27758781ba7f3ee177f0bc4079311469ba8c399d0a252c48937ad4a0a8f'
AND (
token = 'KosHUABdJuCw+vshuwGBrqnpmtu2flEB9uR/i7JUe9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)