UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GjRa0gVnwox4hakYIKvYWgGUC52exB12LHpX/+iY/Y='
WHERE
key_id = 'b1171cddd4282ac136b81c61375af3926c6e764230bda712a076161a75813a2d'
AND (
token = '7GjRa0gVnwox4hakYIKvYWgGUC52exB12LHpX/+iY/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)