UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yiqw0NQmAWyqMejIGEkjx0ZNmrBI5uPgAmmyYjiVvm8='
WHERE
key_id = '76d98fa6599b528af3fd799441982109e3910d7affe669f0b8f615c4c771b6d4'
AND (
token = 'Yiqw0NQmAWyqMejIGEkjx0ZNmrBI5uPgAmmyYjiVvm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)