UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pauhhm7YC1Z8iSOwx0gn7ki/oc5gJW36vtrD23JEtCo='
WHERE
key_id = '2593733e811aa5727a7e959f8ee111a98edb9318e6768f4804211dfb98ec3856'
AND (
token = 'Pauhhm7YC1Z8iSOwx0gn7ki/oc5gJW36vtrD23JEtCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)