UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhckctAjHeZmjEjF0i0yXX+8v7hHywFk8+g4AA1pAeM='
WHERE
key_id = '05201d38466cec41f0cd8bdd851a0eda7a23adee91fbee47255584fd889e4cf1'
AND (
token = 'HhckctAjHeZmjEjF0i0yXX+8v7hHywFk8+g4AA1pAeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)