UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kIERdqCIWbppiIXiyBfvNNCDgQ0QdGPBgdprv4cXJCk='
WHERE
key_id = '50b91643412fd936b4ebcbd0815c9fe75d952606491d109234959b64acc871b8'
AND (
token = 'kIERdqCIWbppiIXiyBfvNNCDgQ0QdGPBgdprv4cXJCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)