UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K8yeyFKWdQCiQr1IQWf9MyuVOUgtcDIq2LH3k8rW1A4='
WHERE
key_id = '473eb92706980cc1eac1447ae3b51ef91fbe607c5e0ce3d48878eb78f97dd47f'
AND (
token = 'K8yeyFKWdQCiQr1IQWf9MyuVOUgtcDIq2LH3k8rW1A4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)