UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '10NX4aw1DxJZhgSSqwmIZqq84Vj0M3ZdCDiaf2lkOMA='
WHERE
key_id = '82942637de19fec59085769ac27f5bafef4059aa878c649ccef452e9f97e21de'
AND (
token = '10NX4aw1DxJZhgSSqwmIZqq84Vj0M3ZdCDiaf2lkOMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)