UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYB41uxwcHYobGkFWjf2LHJgIFafJdt8aAohyyr7xdA='
WHERE
key_id = '8a7aeb54becf071e9de3b678cf3e3210bdf1ac7ecde079749e3c386eb9917753'
AND (
token = 'ZYB41uxwcHYobGkFWjf2LHJgIFafJdt8aAohyyr7xdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)