UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0g9QC3H4so2WbyA+rZqOApyeglhhNmKXK2enFir0BdU='
WHERE
key_id = '7d236519876f3e382a32e16a3540718e15ca13d70fa728eeec6a243772d7caee'
AND (
token = '0g9QC3H4so2WbyA+rZqOApyeglhhNmKXK2enFir0BdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)