UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ho3MUY0EH7g5Sa9sKisuf1UKNOuT6epAIc5rZ6aizUg='
WHERE
key_id = '4e0921a659b812eab8784031aaf25902c74f87b1689ab1833518a1d47c1400b5'
AND (
token = 'ho3MUY0EH7g5Sa9sKisuf1UKNOuT6epAIc5rZ6aizUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)