UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd6PlrV31REh+e8VVjowoIq0gZNZrj0ogQ6pUkUvqqbM='
WHERE
key_id = 'd846ea88321ab141c8003fbf18882c7c8899a1eacba476bce9f9bba983c5b13d'
AND (
token = 'd6PlrV31REh+e8VVjowoIq0gZNZrj0ogQ6pUkUvqqbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)