UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XS55QyA+wqCDL2SmtXIjRNsZmRVj2NacwxadEN0tBc='
WHERE
key_id = 'a6c2c9203efa91b3f0f3d65960a9c0462b83acb5cfcd9c37ccebe10c99208b65'
AND (
token = '0XS55QyA+wqCDL2SmtXIjRNsZmRVj2NacwxadEN0tBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)