UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAxns4Q66d6VU8yJjf5gc8B0fv3EWGOpLYP4F6dNJrU='
WHERE
key_id = 'e0a9bc593d612a52d442cb09080c9d08bed90eb8ea116793ff58c2b339719be7'
AND (
token = 'hAxns4Q66d6VU8yJjf5gc8B0fv3EWGOpLYP4F6dNJrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)