UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HuEHGHdLHrjBk7LVNxJ+CstG3XTrtp3e4ihaoo/3Zpc='
WHERE
key_id = '23660cc4fae67911203a6481478200feab7fad284fcc874f6278c3320e3e1649'
AND (
token = 'HuEHGHdLHrjBk7LVNxJ+CstG3XTrtp3e4ihaoo/3Zpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)