UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/7dwf1+wf/cKbZLvmmxMq4DTp+mOeeMWNfOWMgJYBY='
WHERE
key_id = '59d6e563f6c286bfc4415d8b90333168d24ef076add1eb46949b62546274476f'
AND (
token = 'P/7dwf1+wf/cKbZLvmmxMq4DTp+mOeeMWNfOWMgJYBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)