UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6e9L0lOxoDWNU7lZy24MKJGcDF93TqoCW9C2+HaDRvw='
WHERE
key_id = '42cb6bde0ac8a730b6b4e66ce17f97156e8099aa89cf83e35fbb440a97d5266d'
AND (
token = '6e9L0lOxoDWNU7lZy24MKJGcDF93TqoCW9C2+HaDRvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)